

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/online_education?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from class_studying_student_count where 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database ole_ods \
--hcatalog-table class_studying_student_count \
--m 1



/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/online_education?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from course_table_upload_detail where 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database ole_ods \
--hcatalog-table course_table_upload_detail \
--m 1



/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/online_education?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from student_leave_apply where 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database ole_ods \
--hcatalog-table student_leave_apply \
--m 1



/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/online_education?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from tbh_class_time_table where 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database ole_ods \
--hcatalog-table tbh_class_time_table \
--m 1



/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/online_education?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from tbh_student_signin_record where 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database ole_ods \
--hcatalog-table tbh_student_signin_record \
--m 1






